package com.dlnu.sujiwords.dao;

import com.dlnu.sujiwords.domain.pojo.EnWords;
import org.apache.ibatis.annotations.Param;
import java.util.List;

public interface EnWordsMapper {
    List<EnWords> spotCheck(@Param("spotid") List<Integer> spotids);
    /*英译汉*/
    EnWords EnToCh(String eng);
    /*汉译英*/
    List<EnWords> ChToEn(String cn);

    /*单个词表查询*/
    List<EnWords> selSchools();
    List<EnWords> selHigh_school();
    List<EnWords> selCET_4();
    List<EnWords> selCET_6();
    List<EnWords> selPostgraduata_word();
    List<EnWords> selEnwords();
    /*单表总数据量查询*/
    int selSchoolsTotal();
    int selHigh_schoolTotal();
    int selCET_4Total();
    int selCET_6Total();
    int selPostgraduata_wordTotal();
    int selEnwordsTotal();

    /*翻译和单词模糊查询*/
    List<EnWords> searchWordFromSchools(EnWords word);
    List<EnWords> searchWordFromHigh_school(EnWords word);
    List<EnWords> searchWordFromCET_4(EnWords word);
    List<EnWords> searchWordFromCET_6(EnWords word);
    List<EnWords> searchWordFromPostgraduata_word(EnWords word);
    List<EnWords> searchWordFromEnwords(EnWords word);
    /*通过id获取单词*/
    EnWords getWordByIdFromSchools(int id);
    EnWords getWordByIdFromHigh_school(int id);
    EnWords getWordByIdFromCET_4(int id);
    EnWords getWordByIdFromCET_6(int id);
    EnWords getWordByIdFromPostgraduata_word(int id);
    EnWords getWordByIdFromEnwords(int id);

}
